package stud.aistar.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import stud.aistar.entity.WorkTime;

import java.util.List;

/**
 * Created by Jcdz on 2019/9/28.
 */
public interface WorkTimeMapper {

    @Select("select * from worktime")
    List<WorkTime> findAll();

    @Select("select status from worktime where doc_id=#{did} and time_id=#{tid}")
    Integer findStatusByDocIdAndTimeId(@Param("did") Integer did, @Param("tid") Integer tid);


    @Select("select * from worktime where doc_id=#{value}")
    List<WorkTime> findByDocId(Integer id);

}
